{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["beam design"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"beam design","index":0,"n_rows":109,"n_cols":37,"rows_kept":109,"cut":false,"hidden":false,"merged":[[41,1,41,3],[0,0,0,12],[10,4,10,5],[6,13,6,14],[5,0,5,12],[40,1,40,3],[8,7,8,9],[9,7,9,9],[10,7,10,9],[20,1,20,3],[21,1,21,3],[6,7,6,12],[18,1,18,3],[17,1,17,3],[19,1,19,3],[8,0,9,0],[25,0,28,0],[29,0,32,0],[34,1,34,3],[10,10,10,11],[22,1,22,3],[23,1,23,3],[13,1,13,6],[10,1,10,3],[16,1,16,3],[11,1,11,3],[12,1,12,3],[14,1,14,3],[15,1,15,3],[3,10,3,11],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[29,1,32,2],[25,1,28,2],[6,1,6,6],[7,7,7,9],[7,1,7,3],[8,1,9,2]]}
["DESIGN OF BEAM"]
[null,"Project name:"]
[null,"Structure name"]
[null,"Drawing refer to",null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2025-02-18"}]
[null,"Prepared by:",null,null,null,"Checked by:",null,null,null,"Recommended by:"]
[]
[null,"Design parameters",null,null,null,null,null,"Size of beams"]
[null,"Grade of Concrete",null,null,"fck",35,null,"Depth ",null,null,"d",1500,"mm"]
[null,"Steel grade",null,"Main bar","fy",500,"N/mm2","Breadth",null,null,"b",1000,"mm"]
[null,null,null,"Shear","fs",250,"N/mm2","Effective length of beam",null,null,"l",5.9,"m"]
[null,"Types of bars",null,null,"Deformed",null,null,"Types of beam",null,null,"Simply Supported"]
[null,"Clear Cover",null,null,"dc",30,"mm","A. Serviceability Limit state"]
[null,"Modulus of Elasticity of Steel",null,null,"Es",200000,"N/mm2","A.1 Effective depth requirement",null,null,"de",{"$f":"de(K11,L8,F12,L10,E26)","v":1457.5},"mm"]
[null,"REINFORCEMENT DESIGN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Left section (Section-1)",null,null,null,"Mid (Section-2)",null,null,null,"Section-3"]
[null,null,null,null,"Lelft","Mid","Right",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beam section",null,null,null,"Beam section",null,null,null,"Beam Section"]
[null,"Moment ",null,null,400,2000,300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","y",null,null,"x","y",null,null,"x","y"]
[null,"Shear force",null,null,1000,15,900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,{"$f":"AA17","v":0},{"$f":"AB17","v":0},null,null,{"$f":"AE17","v":0},{"$f":"AF17","v":0}]
["A.2 ","Limit state of strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA17+L9","v":1000},{"$f":"AB17","v":0},null,null,{"$f":"AA18","v":1000},0,null,null,{"$f":"AE18","v":1000},0]
[null,"Moment of resistance",null,null,{"$f":"MR(F8,F9,L9,L13,F12,F13)","v":9868.2634197179814},{"$f":"MR(F8,F9,L9,L13,F12,F13)","v":9868.2634197179814},{"$f":"MR(F8,F9,L9,L13,F12,F13)","v":9868.2634197179814},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA18","v":1000},{"$f":"AB18+L8","v":1500},null,null,1000,1500,null,null,1000,1500]
[null,"1. Main reinforcement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA17","v":0},{"$f":"AB19","v":1500},null,null,0,1500,null,null,0,1500]
[null,"Types of reinforcement",null,null,{"$f":"IF(E19<E16,\"Doubly\",\"Singly\")","v":"Singly"},{"$f":"IF(F19<F16,\"Doubly\",\"Singly\")","v":"Singly"},{"$f":"IF(G19<G16,\"Doubly\",\"Singly\")","v":"Singly"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA17","v":0},{"$f":"AB17","v":0},null,null,0,0,null,null,0,0]
[null,"Tension reinforcement",null,null,{"$f":"Ast(E16,F8,F9,E23,L9,L13,F12,F13)","v":2477.75},{"$f":"Ast(F16,F8,F9,E23,L9,L13,F12,F13)","v":3258.8074071753044},{"$f":"Ast(E16,F8,F9,E23,L9,L13,F12,F13)","v":2477.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dimension",null,null,null,"Dimension",null,null,null,"Dimension"]
[null,"Compression calculated",null,null,{"$f":"Acs(E16,F8,F9,L9,L13,F12,F13)","v":0},{"$f":"Acs(F16,F8,F9,L9,L13,F12,F13)","v":0},{"$f":"Acs(G16,F8,F9,L9,L13,F12,F13)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA17","v":0},{"$f":"AB19+100","v":1600},null,null,{"$f":"AA23","v":0},{"$f":"AB23","v":1600},null,null,{"$f":"AE23","v":0},{"$f":"AF23","v":1600}]
[null,"Revised Area of compression reinforcement",null,null,{"$f":"IF(E23<50%*E22,50%*E22,E23)","v":1238.875},{"$f":"IF(F23<50%*F22,50%*F22,F23)","v":1629.4037035876522},1238.875,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA18","v":1000},{"$f":"AB23","v":1600},null,null,{"$f":"AA24","v":1000},1600,null,null,{"$f":"AE24","v":1000},1600]
[null,"Reinforcement Provided",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA18+100","v":1100},{"$f":"AB17","v":0},null,null,1100,0,null,null,1100,0]
[null,"Tension reinforcement",null,"Dia",25,25,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA25","v":1100},{"$f":"AB19","v":1500},null,null,1100,1500,null,null,1100,1500]
[null,null,null,"Number",{"$f":"IF(ROUNDUP(E22/(PI()*E26^2/4),5)<=2,2,ROUNDUP(E22/(PI()*E26^2/4),0))","v":6},{"$f":"IF(ROUNDUP(F22/(PI()*F26^2/4),5)<=2,2,ROUNDUP(F22/(PI()*F26^2/4),0))","v":7},6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tension reinforcement",null,null,null,"Tension reinforcement",null,null,null,"Tension reinforcement"]
[null,null,null,"Area",{"$f":"PI()*E26^2/4*E27","v":2945.2431127404311},{"$f":"PI()*F26^2/4*F27","v":3436.1169648638361},2945.2431127404311,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"First rebar",{"$f":"F12+E35+E26/2","v":52.5},"mm",null,"First rebar",{"$f":"AB28","v":52.5},null,null,"First rebar",{"$f":"AF28","v":52.5}]
[null,null,null,"Percentage",{"$f":"E28/($L$9*$L$13)*100","v":0.20207499915886321},{"$f":"F28/($L$9*$L$13)*100","v":0.23575416568534041},0.20207499915886321,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spacing",40,"mm",null,"Spacing",null,null,null,"Spacing"]
[null,"Compression reinforcement",null,"Diameter",25,25,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nos","x","y",null,"Nos","x","y",null,"Nos","x","y"]
[null,null,null,"Number",{"$f":"IF(ROUNDUP(E24/(PI()*E30^2/4),5)<=2,2,ROUNDUP(E24/(PI()*E30^2/4),0))","v":3},{"$f":"IF(ROUNDUP(F24/(PI()*F30^2/4),5)<=2,2,ROUNDUP(F24/(PI()*F30^2/4),0))","v":4},3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,52.5,1447.5,null,1,52.5,52.5,null,1,52.5,1447.5]
[null,null,null,"Area",{"$f":"PI()*E30^2/4*E31","v":1472.6215563702156},{"$f":"PI()*F30^2/4*F31","v":1963.4954084936207},{"$f":"PI()*G30^2/4*G31","v":1472.6215563702156},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,231.5,1447.5,null,2,201.66666666666666,52.5,null,2,231.5,1447.5]
[null,null,null,"Percentage",{"$f":"E32/($L$9*$L$13)*100","v":0.1010374995794316},{"$f":"F32/($L$9*$L$13)*100","v":0.13471666610590879},{"$f":"G32/($L$9*$L$13)*100","v":0.1010374995794316},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,410.5,1447.5,null,3,350.83333333333331,52.5,null,3,410.5,1447.5]
[null,"2. Shear reinforcement",null,null,null,null,null,null,null,null,"Print report-->","Skip print",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,589.5,1447.5,null,4,500,52.5,null,4,589.5,1447.5]
[null,"Diameter of reinforcement",null,null,10,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,768.5,1447.5,null,5,649.16666666666663,52.5,null,5,768.5,1447.5]
[null,"No. of legs",null,null,3,3,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,947.5,1447.5,null,6,798.33333333333326,52.5,null,6,947.5,1447.5]
[null,"Area of rebar",null,null,{"$f":"E36*PI()*E35^2/4","v":235.61944901923448},{"$f":"F36*PI()*F35^2/4","v":235.61944901923448},{"$f":"G36*PI()*G35^2/4","v":235.61944901923448},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,947.5,52.5]
[null,"Spacing",null,null,{"$f":"ROUNDDOWN(space(E17,F8,F10,E28,L9,L13,E37),0)","v":147},{"$f":"ROUNDDOWN(space(F17,F8,F10,F28,L9,L13,F37),0)","v":128},{"$f":"ROUNDDOWN(space(G17,F8,F10,G28,L9,L13,G37),0)","v":183}]
[]
["A.3 ","3. Development length",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compression reinforcement",null,null,null,"Compression reinforcement",null,null,null,"Compression reinforcement"]
[null,"Development length for Tension rebar",null,null,"Ldt",{"$f":"TBlength(E11,F8,F9,E26)","v":1148.8970588235293},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nos","x","y",null,"Nos","x","y",null,"Nos","x","y"]
[null,"Development length for Compression rebar",null,null,"Ldc",{"$f":"CBlength(E11,F8,F9,E30)","v":919.11764705882354},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,52.5,52.5,null,1,52.5,1447.5,null,1,52.5,52.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,500,52.5,null,2,350.83333333333331,1447.5,null,2,500,52.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,947.5,52.5,null,3,649.16666666666663,1447.5,null,3,947.5,52.5]
[null,null,{"$f":"CONCATENATE(E27,\"-\",E26,\" mm dia \")","v":"6-25 mm dia "},null,{"$f":"CONCATENATE(E36,\"L-\",E35,\" mm dia @ \",E38,\" mm c/s\")","v":"3L-10 mm dia @ 147 mm c/s"},null,null,null,{"$f":"CONCATENATE(G27,\"-\",G26,\" mm dia \")","v":"6-25 mm dia "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,947.5,1447.5]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(G36,\"L-\",G35,\" mm dia @ \",G38,\" mm c/c\")","v":"3L-10 mm dia @ 183 mm c/c"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stirrups",null,null,null,null,null,null,null,"Stirrups"]
[null,null,null,{"$f":"CONCATENATE(F27,\"-\",F26,\" mm dia\")","v":"7-25 mm dia"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cover",{"$f":"F12+E35/2","v":35},"mm",null,"Cover",{"$f":"AB53","v":35},null,null,"Cover",{"$f":"AF53","v":35}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(G36,\"L-\",G35,\"mm dia @\",G38,\" mm c/c\")","v":"3L-10mm dia @183 mm c/c"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","y",null,null,"x","y",null,null,"x","y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"AA17+AB53","v":35},{"$f":"AB17+AB53","v":35},null,1,{"$f":"AB55","v":35},{"$f":"AC55","v":35},null,1,{"$f":"AF55","v":35},{"$f":"AG55","v":35}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"L9-AB53","v":965},{"$f":"AC55","v":35},null,2,{"$f":"AB56","v":965},35,null,2,{"$f":"AF56","v":965},35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"AB56","v":965},{"$f":"L8-AB53","v":1465},null,3,965,1465,null,3,965,1465]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"AB55","v":35},{"$f":"AC57","v":1465},null,4,35,1465,null,4,35,1465]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"AB55","v":35},{"$f":"AC55","v":35},null,5,35,35,null,5,35,35]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,52.5,52.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,500,52.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,947.5,52.5]